﻿CREATE TABLE [Core].[User] (
    [UserId]         UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [ContactId]      UNIQUEIDENTIFIER NOT NULL,
    [BusinessUnitId] UNIQUEIDENTIFIER NOT NULL,
    [IsDroppedYN]    NCHAR (1)        NOT NULL,
    [CreateDT]       DATETIME         NOT NULL,
    [CreatedById]    UNIQUEIDENTIFIER NOT NULL,
    [CreatedByName]  NVARCHAR (127)   NOT NULL,
    [ModifiedDT]     DATETIME         NOT NULL,
    [ModifiedById]   UNIQUEIDENTIFIER NOT NULL,
    [ModifiedByName] NVARCHAR (127)   NOT NULL
);

